oracle数据库 判断A列的值是否存在与B列。答:create table test(name1 varchar2(100),name2 varchar2(100),flag int);insert into test (name1,name2) values ('苹果','苹果,香蕉,荔枝');insert into test (name1,name2) values ('苹果','葡萄,香蕉,荔枝');commit;如果查询的话:select name1,name2,case when instr(name2,name1)...
oracle 某个表的字段值是用逗号分隔的,如 a,b,c,我想统计 包含a的有多 ...答:select sum(decode(instr( x_field , 'A'),0,0,1)) a_sum,sum(decode(instr( x_field , 'B'),0,0,1)) b_sum,sum(decode(instr( x_field , 'C'),0,0,1)) c_sum,from x_tab